Release 10.1A: OpenEdge Data Management:
SQL Reference

SYSINDEXES

Contains one row for each component of an index in the database. For an index with n components, there will be n rows in this table.

Table 7 provides details of the SYSINDEXES table.

Table 7: SYSINDEXES core system table  

Column name	Column data type	Column size
abbreviate	BIT	1
active	BIT	1
creator	VARCHAR	32
colname	VARCHAR	32
desc	VARCHAR	144
id	INTEGER	4
idxcompress	VARCHAR	1
idxmethod	VARCHAR	2
idxname	VARCHAR	32
idxorder	CHARACTER	1
idxowner	VARCHAR	32
idxsegid	INTEGER	4
idxseq	INTEGER	4
ixcol_user_misc	VARCHAR	20
rssid	INTEGER	4
tbl	VARCHAR	32
tblowner	VARCHAR	32